SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_UpdateApplyField]
    (
      @JOL_Field_No INT ,
      @JOL_Field_ApplyCompany VARCHAR(50) ,
      @JOL_Field_Purpose VARCHAR(50) ,--场地用途
      @JOL_Field_Linkman VARCHAR(50) ,--联系人
      @JOL_Field_Contact VARCHAR(50) ,--联系方式
      @JOL_Field_Action VARCHAR(100) ,--活动
      @JOL_Field_ApplyTime DATETIME ,--时间
      @JOL_Field_ApplyPosition VARCHAR(50) ,--地点
      @JOL_Field_SeatNumber INT ,--人数
      @JOL_Field_IsProvideMultimedia BIT ,--是否使用多媒体
      @JOL_Field_IsNeedInvoice BIT ,--是否需要发票
      @JOL_Field_InvoiceBeginning VARCHAR(50) ,--发票开头
      @JOL_Field_InvoiceProject VARCHAR(50) ,--发票项目
      @JOL_Field_IsPaidMoney BIT ,--是否已缴费，中心管理员填写
      @JOL_Field_UpdateTime DATETIME ,--更新时间
      @JOL_Field_UpdateUser VARCHAR(50) ,--更新账户
      @JOL_Field_Remark NTEXT ,--备注
      @JOL_ApplyField_EndTime DATETIME ,
      @JOL_ApplyField_Phone VARCHAR(50) ,
      @JOL_ApplyField_Fax VARCHAR(50) ,
      @JOL_ApplyField_Email VARCHAR(50),
      @JOL_ApplyField_VerifyStatus VARCHAR(50),
      @JOL_ApplyField_VerifyUser VARCHAR(50)
    )
AS 
    UPDATE  dbo.JOL_ApplyField
    SET     JOL_Field_ApplyCompany = @JOL_Field_ApplyCompany ,
            JOL_Field_Purpose = @JOL_Field_Purpose ,
            JOL_Field_Linkman = @JOL_Field_Linkman ,
            JOL_Field_Contact = @JOL_Field_Contact ,
            JOL_Field_Action = @JOL_Field_Action ,
            JOL_Field_ApplyTime = @JOL_Field_ApplyTime ,
            JOL_Field_ApplyPosition = @JOL_Field_ApplyPosition ,
            JOL_Field_SeatNumber = @JOL_Field_SeatNumber ,
            JOL_Field_IsProvideMultimedia = @JOL_Field_IsProvideMultimedia ,
            JOL_Field_IsNeedInvoice = @JOL_Field_IsNeedInvoice ,
            JOL_Field_InvoiceBeginning = @JOL_Field_InvoiceBeginning ,
            JOL_Field_InvoiceProject = @JOL_Field_InvoiceProject ,
            JOL_Field_IsPaidMoney = @JOL_Field_IsPaidMoney ,
            JOL_Field_UpdateTime = GETDATE() ,
            JOL_Field_UpdateUser = @JOL_Field_UpdateUser ,
            JOL_Field_VerifyStatus = @JOL_ApplyField_VerifyStatus ,
            JOL_Field_VerifyUser = @JOL_ApplyField_VerifyUser ,
            JOL_Field_IsSendEmail = 0 ,
            JOL_Field_Remark = @JOL_Field_Remark ,
            JOL_ApplyField_EndTime = @JOL_ApplyField_EndTime ,
            JOL_ApplyField_Phone = @JOL_ApplyField_Phone ,
            JOL_ApplyField_Fax = @JOL_ApplyField_Fax ,
            JOL_ApplyField_Email = @JOL_ApplyField_Email
    WHERE   JOL_Field_No = @JOL_Field_No



GO
